Edit an exported Unicode text file in Excel

You can edit an exported Unicode text file in Microsoft Excel (recommended).

To edit an exported Unicode text file in Excel

  1. Open Excel, and from the File menu, select Open.
  2. In the Open dialog box, make sure that All Files is selected, select the file you are going to edit, and click Open. The Text Import Wizard opens.
  3. In Step 1 of the Text Import Wizard, select the following options and click Next:
    • Choose the file type that best describes your data: Delimited
    • Start import at row: 1
    • File origin: Windows (ANSI)
  4. In Step 2, select the following options and click Next:
    • Delimiters the data must contain: Tab (make sure the other check boxes are cleared.)
    • Treat consecutive delimiters as one: clear the check box
  5. In Step 3, for Column data format, select General.
  6. Click Finish.

The first seven lines of the Unicode file explain what you can and cannot change in the file.

See also

Prepare an application for language switching

Language Configuration dialog box

Export text strings to a Unicode text file

Save the edited Unicode text file in Excel

Edit an exported Unicode text file in Notepad